package ebcs.database.mybatis.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import ebcs.database.bean.BsGoal;
import ebcs.database.bean.BsNeedInfor;
import ebcs.database.bean.BsNeedInforExample;
import ebcs.database.bean.BsNeedStage;
import ebcs.database.bean.BsNeedTime;
import ebcs.database.bean.BsOnlineNeed;
import ebcs.database.bean.BsSaleNeed;
import ebcs.database.bean.BsUserInfor;
import ebcs.database.bean.NeedConversion;

public interface BsNeedInforMapperSelf {
     
	List<BsNeedInfor> selectByPhoneNo(BsUserInfor user);
	
	List<BsNeedInfor> selectByNeedId(BsNeedInfor bean);
	
    List<BsNeedInfor> selectNeedInfor(BsNeedInfor bean);
    
    int updateNeedNoRelByNeedId(BsNeedInfor bean);
    
    List<BsNeedTime> selectNeedTime(BsUserInfor user);
    List<BsNeedInfor> selectNeedInforDetail(BsNeedInfor bean);
    List<BsNeedInfor> selectNeedInforDetailPage(BsNeedInfor req);
	int selectNeedInforDetailPageCount(BsNeedInfor req);
    

List<BsNeedInfor>selectBankResolve(BsNeedInfor req);

	String selectgscyry(String needId);

	List<BsNeedInfor> selectBankSummary();

	List<BsNeedInfor> selectSoftwareSummary(BsNeedInfor req);

	List<BsNeedInfor> selectBankResolvePage(BsNeedInfor req);
	int selectBankResolvePageCount(BsNeedInfor req);
	//销售系统
	List<BsSaleNeed> selectBsSaleNeedById(String needid);
	int insertSaleNeed(BsSaleNeed req);
	int deleteSaleNeed(String rouid);
	
	//上线数据
	List<BsOnlineNeed> selectBsOnlineNeedById(String needid);
	int insertBsOnlineNeed(BsOnlineNeed req);
	int deleteBsOnlineNeed(String rouid);

	List<BsNeedInfor> selectGoalAndReality(BsNeedInfor req);
	//zxw
	List<BsNeedInfor> selectGoalAndGroup();
	
	List<BsNeedInfor> selectAllGroupIncome();
     //
	List<BsNeedInfor> selectAllTeamIncome(BsNeedInfor req);

	List<BsNeedInfor> selectCurMonthList(BsNeedInfor req);

	List<BsNeedInfor> selectGoalAndRealityTeam(BsNeedInfor req);
	
	//需求过程
	int insertBsNeedStage(BsNeedStage req);

	List<BsNeedStage> selectBsNeedStage(BsNeedStage req);
	int updateBsNeedStage(BsNeedStage req);
	
	int updateBsNeedStageOld(BsNeedStage req);
	
	int updateBsNeedStageNew(BsNeedStage req);
	
	int insertHisStage(BsNeedStage req);
	
	
	
	//团队目标
	int insertteamgoal(BsGoal req);
	int insertgoal(BsGoal req);
	List<BsGoal> selectteamgoal(BsGoal req);
	List<BsGoal> selectgoal(BsGoal req);
	int updateteamgoal(BsGoal req);
	int updategoal(BsGoal req);
	List<BsGoal> selectteamgoalsum(BsGoal req);
	int deleteteamgoal(String rouid);
	
	
	//转化率报表
	List<NeedConversion> selectNeedConversion(NeedConversion req);
	List<NeedConversion> selectConversion();
	

} 